package com.ourteam.system.dao;

import net.dao.BaseQueryBean;
import net.dao.BaseWhereCriterion;
import net.dao.IDataAccessInterface;

import org.apache.commons.lang.StringUtils;

import java.util.Arrays;
import java.util.List;
import java.util.Map;


/**
 * Template Name : DAO查询对象
 * Template Version : 1
 * Template Last Modfiy Date : Sat Aug 19 10:06:32 CST 2017
 * Auto Generate Date : 2018-07-31 15:13:33
  * Warning ! This file will be overwrite when regenerate !
  *
 */
public class SysUserSettingDAOQueryBean extends BaseQueryBean {
    public SysUserSettingDAOQueryBean() {
        super();
    }

    public SysUserSettingDAOQueryBean(BaseQueryBean aQueryBean) {
        super(aQueryBean);
    }

    public SysUserSettingDAOQueryBean(BaseQueryBean aQueryBean,
        Map tableReplaceMap) {
        super(aQueryBean, tableReplaceMap);
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();

        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }

        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        return new Criteria(this);
    }

    public void addIdSelectProperty() {
        addIdSelectProperty("id");
    }

    public void addIdSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysUserSettingDAO.Id, aAlias);
        } else {
            addSelectProperty(ISysUserSettingDAO.Id, "id");
        }
    }

    public void addUserIdSelectProperty() {
        addUserIdSelectProperty("userId");
    }

    public void addUserIdSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysUserSettingDAO.UserId, aAlias);
        } else {
            addSelectProperty(ISysUserSettingDAO.UserId, "userId");
        }
    }

    public void addItemNameSelectProperty() {
        addItemNameSelectProperty("itemName");
    }

    public void addItemNameSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysUserSettingDAO.ItemName, aAlias);
        } else {
            addSelectProperty(ISysUserSettingDAO.ItemName, "itemName");
        }
    }

    public void addItemValueSelectProperty() {
        addItemValueSelectProperty("itemValue");
    }

    public void addItemValueSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysUserSettingDAO.ItemValue, aAlias);
        } else {
            addSelectProperty(ISysUserSettingDAO.ItemValue, "itemValue");
        }
    }

    public void addAllSelectProperties() {
        addIdSelectProperty();

        addUserIdSelectProperty();

        addItemNameSelectProperty();

        addItemValueSelectProperty();
    }

    public static class Criteria extends BaseWhereCriterion<SysUserSettingDAOQueryBean> {
        protected Criteria(SysUserSettingDAOQueryBean aParentObject) {
            super(aParentObject);
        }

        public Criteria andIdIsNull() {
            addCriterion(ISysUserSettingDAO.Id + " is null");

            return this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion(ISysUserSettingDAO.Id + " is not null");

            return this;
        }

        public Criteria andIdIsNotEmpty() {
            addCriterion(ISysUserSettingDAO.Id + " is not null AND " +
                ISysUserSettingDAO.Id + " <> ''");

            return this;
        }

        public Criteria andIdIsEmpty() {
            addCriterion("(" + ISysUserSettingDAO.Id + " is null OR " +
                ISysUserSettingDAO.Id + " = '')");

            return this;
        }

        public Criteria andIdEqualTo(long value) {
            return andIdEqualTo(Long.valueOf(value));
        }

        public Criteria andIdEqualTo(java.lang.Long value) {
            addCriterion(ISysUserSettingDAO.Id + " = ", value, "id");

            return this;
        }

        public Criteria andIdEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysUserSettingDAO.Id);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysUserSettingDAO.Id + " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdNotEqualTo(long value) {
            return andIdNotEqualTo(Long.valueOf(value));
        }

        public Criteria andIdNotEqualTo(java.lang.Long value) {
            addCriterion(ISysUserSettingDAO.Id + " <>", value, "id");

            return this;
        }

        public Criteria andIdNotEqualToOrIsNull(long value) {
            return andIdNotEqualToOrIsNull(Long.valueOf(value));
        }

        public Criteria andIdNotEqualToOrIsNull(java.lang.Long value) {
            addCriterion(ISysUserSettingDAO.Id + " is null OR " +
                ISysUserSettingDAO.Id + " <>", value, "id");

            return this;
        }

        public Criteria andIdNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysUserSettingDAO.Id);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysUserSettingDAO.Id + " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdGreaterThan(long value) {
            return andIdGreaterThan(Long.valueOf(value));
        }

        public Criteria andIdGreaterThan(java.lang.Long value) {
            addCriterion(ISysUserSettingDAO.Id + " >", value, "id");

            return this;
        }

        public Criteria andIdGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysUserSettingDAO.Id);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysUserSettingDAO.Id + " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdGreaterThanOrEqualTo(long value) {
            return andIdGreaterThanOrEqualTo(Long.valueOf(value));
        }

        public Criteria andIdGreaterThanOrEqualTo(java.lang.Long value) {
            addCriterion(ISysUserSettingDAO.Id + " >=", value, "id");

            return this;
        }

        public Criteria andIdGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysUserSettingDAO.Id);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysUserSettingDAO.Id + " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdLessThan(long value) {
            return andIdLessThan(Long.valueOf(value));
        }

        public Criteria andIdLessThan(java.lang.Long value) {
            addCriterion(ISysUserSettingDAO.Id + " <", value, "id");

            return this;
        }

        public Criteria andIdLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysUserSettingDAO.Id);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysUserSettingDAO.Id + " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdLessThanOrEqualTo(long value) {
            return andIdLessThanOrEqualTo(Long.valueOf(value));
        }

        public Criteria andIdLessThanOrEqualTo(java.lang.Long value) {
            addCriterion(ISysUserSettingDAO.Id + " <=", value, "id");

            return this;
        }

        public Criteria andIdLessThanOrEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysUserSettingDAO.Id);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdLessThanOrEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysUserSettingDAO.Id + " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdIn(long[] values) {
            if (values.length == 1) {
                return andIdEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(ISysUserSettingDAO.Id + " in", values, "id");

                return this;
            }
        }

        public Criteria andIdNotIn(long[] values) {
            if (values.length == 1) {
                return andIdNotEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(ISysUserSettingDAO.Id + " not in", values, "id");

                return this;
            }
        }

        public Criteria andIdIn(List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andIdEqualTo(values.get(0));
            } else {
                addCriterion(ISysUserSettingDAO.Id + " in", values, "id");

                return this;
            }
        }

        public Criteria andIdNotIn(List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andIdNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysUserSettingDAO.Id + " not in", values, "id");

                return this;
            }
        }

        public Criteria andIdIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andIdEqualTo(values[0]);
            } else {
                addCriterion(ISysUserSettingDAO.Id + " in",
                    Arrays.asList(values), "id");

                return this;
            }
        }

        public Criteria andIdNotIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andIdNotEqualTo(values[0]);
            } else {
                addCriterion(ISysUserSettingDAO.Id + " not in",
                    Arrays.asList(values), "id");

                return this;
            }
        }

        public Criteria andIdIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysUserSettingDAO.Id + " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysUserSettingDAO.Id + " not in ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdBetween(long value1, long value2) {
            addCriterion(ISysUserSettingDAO.Id + " between", value1, value2,
                "id");

            return this;
        }

        public Criteria andIdBetween(java.lang.Long value1,
            java.lang.Long value2) {
            addCriterion(ISysUserSettingDAO.Id + " between", value1, value2,
                "id");

            return this;
        }

        public Criteria andIdNotBetween(long value1, long value2) {
            addCriterion(ISysUserSettingDAO.Id + " not between", value1,
                value2, "id");

            return this;
        }

        public Criteria andIdNotBetween(java.lang.Long value1,
            java.lang.Long value2) {
            addCriterion(ISysUserSettingDAO.Id + " not between", value1,
                value2, "id");

            return this;
        }

        public Criteria andUserIdIsNull() {
            addCriterion(ISysUserSettingDAO.UserId + " is null");

            return this;
        }

        public Criteria andUserIdIsNotNull() {
            addCriterion(ISysUserSettingDAO.UserId + " is not null");

            return this;
        }

        public Criteria andUserIdIsNotEmpty() {
            addCriterion(ISysUserSettingDAO.UserId + " is not null AND " +
                ISysUserSettingDAO.UserId + " <> ''");

            return this;
        }

        public Criteria andUserIdIsEmpty() {
            addCriterion("(" + ISysUserSettingDAO.UserId + " is null OR " +
                ISysUserSettingDAO.UserId + " = '')");

            return this;
        }

        public Criteria andUserIdEqualTo(long value) {
            return andUserIdEqualTo(Long.valueOf(value));
        }

        public Criteria andUserIdEqualTo(java.lang.Long value) {
            addCriterion(ISysUserSettingDAO.UserId + " = ", value, "userId");

            return this;
        }

        public Criteria andUserIdEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysUserSettingDAO.UserId);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andUserIdEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysUserSettingDAO.UserId + " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andUserIdNotEqualTo(long value) {
            return andUserIdNotEqualTo(Long.valueOf(value));
        }

        public Criteria andUserIdNotEqualTo(java.lang.Long value) {
            addCriterion(ISysUserSettingDAO.UserId + " <>", value, "userId");

            return this;
        }

        public Criteria andUserIdNotEqualToOrIsNull(long value) {
            return andUserIdNotEqualToOrIsNull(Long.valueOf(value));
        }

        public Criteria andUserIdNotEqualToOrIsNull(java.lang.Long value) {
            addCriterion(ISysUserSettingDAO.UserId + " is null OR " +
                ISysUserSettingDAO.UserId + " <>", value, "userId");

            return this;
        }

        public Criteria andUserIdNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysUserSettingDAO.UserId);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andUserIdNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysUserSettingDAO.UserId + " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andUserIdGreaterThan(long value) {
            return andUserIdGreaterThan(Long.valueOf(value));
        }

        public Criteria andUserIdGreaterThan(java.lang.Long value) {
            addCriterion(ISysUserSettingDAO.UserId + " >", value, "userId");

            return this;
        }

        public Criteria andUserIdGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysUserSettingDAO.UserId);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andUserIdGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysUserSettingDAO.UserId + " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andUserIdGreaterThanOrEqualTo(long value) {
            return andUserIdGreaterThanOrEqualTo(Long.valueOf(value));
        }

        public Criteria andUserIdGreaterThanOrEqualTo(java.lang.Long value) {
            addCriterion(ISysUserSettingDAO.UserId + " >=", value, "userId");

            return this;
        }

        public Criteria andUserIdGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysUserSettingDAO.UserId);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andUserIdGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysUserSettingDAO.UserId + " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andUserIdLessThan(long value) {
            return andUserIdLessThan(Long.valueOf(value));
        }

        public Criteria andUserIdLessThan(java.lang.Long value) {
            addCriterion(ISysUserSettingDAO.UserId + " <", value, "userId");

            return this;
        }

        public Criteria andUserIdLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysUserSettingDAO.UserId);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andUserIdLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysUserSettingDAO.UserId + " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andUserIdLessThanOrEqualTo(long value) {
            return andUserIdLessThanOrEqualTo(Long.valueOf(value));
        }

        public Criteria andUserIdLessThanOrEqualTo(java.lang.Long value) {
            addCriterion(ISysUserSettingDAO.UserId + " <=", value, "userId");

            return this;
        }

        public Criteria andUserIdLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysUserSettingDAO.UserId);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andUserIdLessThanOrEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysUserSettingDAO.UserId + " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andUserIdIn(long[] values) {
            if (values.length == 1) {
                return andUserIdEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(ISysUserSettingDAO.UserId + " in", values, "userId");

                return this;
            }
        }

        public Criteria andUserIdNotIn(long[] values) {
            if (values.length == 1) {
                return andUserIdNotEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(ISysUserSettingDAO.UserId + " not in", values,
                    "userId");

                return this;
            }
        }

        public Criteria andUserIdIn(List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andUserIdEqualTo(values.get(0));
            } else {
                addCriterion(ISysUserSettingDAO.UserId + " in", values, "userId");

                return this;
            }
        }

        public Criteria andUserIdNotIn(List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andUserIdNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysUserSettingDAO.UserId + " not in", values,
                    "userId");

                return this;
            }
        }

        public Criteria andUserIdIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andUserIdEqualTo(values[0]);
            } else {
                addCriterion(ISysUserSettingDAO.UserId + " in",
                    Arrays.asList(values), "userId");

                return this;
            }
        }

        public Criteria andUserIdNotIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andUserIdNotEqualTo(values[0]);
            } else {
                addCriterion(ISysUserSettingDAO.UserId + " not in",
                    Arrays.asList(values), "userId");

                return this;
            }
        }

        public Criteria andUserIdIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysUserSettingDAO.UserId + " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andUserIdNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysUserSettingDAO.UserId + " not in ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andUserIdBetween(long value1, long value2) {
            addCriterion(ISysUserSettingDAO.UserId + " between", value1,
                value2, "userId");

            return this;
        }

        public Criteria andUserIdBetween(java.lang.Long value1,
            java.lang.Long value2) {
            addCriterion(ISysUserSettingDAO.UserId + " between", value1,
                value2, "userId");

            return this;
        }

        public Criteria andUserIdNotBetween(long value1, long value2) {
            addCriterion(ISysUserSettingDAO.UserId + " not between", value1,
                value2, "userId");

            return this;
        }

        public Criteria andUserIdNotBetween(java.lang.Long value1,
            java.lang.Long value2) {
            addCriterion(ISysUserSettingDAO.UserId + " not between", value1,
                value2, "userId");

            return this;
        }

        public Criteria andItemNameIsNull() {
            addCriterion(ISysUserSettingDAO.ItemName + " is null");

            return this;
        }

        public Criteria andItemNameIsNotNull() {
            addCriterion(ISysUserSettingDAO.ItemName + " is not null");

            return this;
        }

        public Criteria andItemNameIsNotEmpty() {
            addCriterion(ISysUserSettingDAO.ItemName + " is not null AND " +
                ISysUserSettingDAO.ItemName + " <> ''");

            return this;
        }

        public Criteria andItemNameIsEmpty() {
            addCriterion("(" + ISysUserSettingDAO.ItemName + " is null OR " +
                ISysUserSettingDAO.ItemName + " = '')");

            return this;
        }

        public Criteria andItemNameEqualTo(String value) {
            addCriterion(ISysUserSettingDAO.ItemName + " = ", value, "itemName");

            return this;
        }

        public Criteria andItemNameEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysUserSettingDAO.ItemName);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andItemNameEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysUserSettingDAO.ItemName + " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andItemNameNotEqualTo(String value) {
            addCriterion(ISysUserSettingDAO.ItemName + " <>", value, "itemName");

            return this;
        }

        public Criteria andItemNameNotEqualToOrIsNull(String value) {
            addCriterion(ISysUserSettingDAO.ItemName + " is null OR " +
                ISysUserSettingDAO.ItemName + " <>", value, "itemName");

            return this;
        }

        public Criteria andItemNameNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysUserSettingDAO.ItemName);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andItemNameNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysUserSettingDAO.ItemName + " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andItemNameGreaterThan(String value) {
            addCriterion(ISysUserSettingDAO.ItemName + " >", value, "itemName");

            return this;
        }

        public Criteria andItemNameGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysUserSettingDAO.ItemName);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andItemNameGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysUserSettingDAO.ItemName + " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andItemNameGreaterThanOrEqualTo(String value) {
            addCriterion(ISysUserSettingDAO.ItemName + " >=", value, "itemName");

            return this;
        }

        public Criteria andItemNameGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysUserSettingDAO.ItemName);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andItemNameGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysUserSettingDAO.ItemName + " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andItemNameLessThan(String value) {
            addCriterion(ISysUserSettingDAO.ItemName + " <", value, "itemName");

            return this;
        }

        public Criteria andItemNameLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysUserSettingDAO.ItemName);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andItemNameLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysUserSettingDAO.ItemName + " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andItemNameLessThanOrEqualTo(String value) {
            addCriterion(ISysUserSettingDAO.ItemName + " <=", value, "itemName");

            return this;
        }

        public Criteria andItemNameLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysUserSettingDAO.ItemName);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andItemNameLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysUserSettingDAO.ItemName + " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andItemNameLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysUserSettingDAO.ItemName + " like",
                buffer.toString(), "itemName");

            return this;
        }

        public Criteria andItemNameNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysUserSettingDAO.ItemName + " not like",
                buffer.toString(), "itemName");

            return this;
        }

        public Criteria andItemNameIn(List<String> values) {
            if (values.size() == 1) {
                return andItemNameEqualTo(values.get(0));
            } else {
                addCriterion(ISysUserSettingDAO.ItemName + " in", values,
                    "itemName");

                return this;
            }
        }

        public Criteria andItemNameNotIn(List<String> values) {
            if (values.size() == 1) {
                return andItemNameNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysUserSettingDAO.ItemName + " not in", values,
                    "itemName");

                return this;
            }
        }

        public Criteria andItemNameIn(String[] values) {
            if (values.length == 1) {
                return andItemNameEqualTo(values[0]);
            } else {
                addCriterion(ISysUserSettingDAO.ItemName + " in",
                    Arrays.asList(values), "itemName");

                return this;
            }
        }

        public Criteria andItemNameNotIn(String[] values) {
            if (values.length == 1) {
                return andItemNameNotEqualTo(values[0]);
            } else {
                addCriterion(ISysUserSettingDAO.ItemName + " not in",
                    Arrays.asList(values), "itemName");

                return this;
            }
        }

        public Criteria andItemNameIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysUserSettingDAO.ItemName + " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andItemNameNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysUserSettingDAO.ItemName + " not in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andItemNameBetween(String value1, String value2) {
            addCriterion(ISysUserSettingDAO.ItemName + " between", value1,
                value2, "itemName");

            return this;
        }

        public Criteria andItemNameNotBetween(String value1, String value2) {
            addCriterion(ISysUserSettingDAO.ItemName + " not between", value1,
                value2, "itemName");

            return this;
        }

        public Criteria andItemValueIsNull() {
            addCriterion(ISysUserSettingDAO.ItemValue + " is null");

            return this;
        }

        public Criteria andItemValueIsNotNull() {
            addCriterion(ISysUserSettingDAO.ItemValue + " is not null");

            return this;
        }

        public Criteria andItemValueIsNotEmpty() {
            addCriterion(ISysUserSettingDAO.ItemValue + " is not null AND " +
                ISysUserSettingDAO.ItemValue + " <> ''");

            return this;
        }

        public Criteria andItemValueIsEmpty() {
            addCriterion("(" + ISysUserSettingDAO.ItemValue + " is null OR " +
                ISysUserSettingDAO.ItemValue + " = '')");

            return this;
        }

        public Criteria andItemValueEqualTo(String value) {
            addCriterion(ISysUserSettingDAO.ItemValue + " = ", value,
                "itemValue");

            return this;
        }

        public Criteria andItemValueEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysUserSettingDAO.ItemValue);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andItemValueEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysUserSettingDAO.ItemValue + " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andItemValueNotEqualTo(String value) {
            addCriterion(ISysUserSettingDAO.ItemValue + " <>", value,
                "itemValue");

            return this;
        }

        public Criteria andItemValueNotEqualToOrIsNull(String value) {
            addCriterion(ISysUserSettingDAO.ItemValue + " is null OR " +
                ISysUserSettingDAO.ItemValue + " <>", value, "itemValue");

            return this;
        }

        public Criteria andItemValueNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysUserSettingDAO.ItemValue);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andItemValueNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysUserSettingDAO.ItemValue + " <> ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andItemValueGreaterThan(String value) {
            addCriterion(ISysUserSettingDAO.ItemValue + " >", value, "itemValue");

            return this;
        }

        public Criteria andItemValueGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysUserSettingDAO.ItemValue);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andItemValueGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysUserSettingDAO.ItemValue + " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andItemValueGreaterThanOrEqualTo(String value) {
            addCriterion(ISysUserSettingDAO.ItemValue + " >=", value,
                "itemValue");

            return this;
        }

        public Criteria andItemValueGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysUserSettingDAO.ItemValue);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andItemValueGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysUserSettingDAO.ItemValue + " >= ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andItemValueLessThan(String value) {
            addCriterion(ISysUserSettingDAO.ItemValue + " <", value, "itemValue");

            return this;
        }

        public Criteria andItemValueLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysUserSettingDAO.ItemValue);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andItemValueLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysUserSettingDAO.ItemValue + " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andItemValueLessThanOrEqualTo(String value) {
            addCriterion(ISysUserSettingDAO.ItemValue + " <=", value,
                "itemValue");

            return this;
        }

        public Criteria andItemValueLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysUserSettingDAO.ItemValue);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andItemValueLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysUserSettingDAO.ItemValue + " <= ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andItemValueLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysUserSettingDAO.ItemValue + " like",
                buffer.toString(), "itemValue");

            return this;
        }

        public Criteria andItemValueNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysUserSettingDAO.ItemValue + " not like",
                buffer.toString(), "itemValue");

            return this;
        }

        public Criteria andItemValueIn(List<String> values) {
            if (values.size() == 1) {
                return andItemValueEqualTo(values.get(0));
            } else {
                addCriterion(ISysUserSettingDAO.ItemValue + " in", values,
                    "itemValue");

                return this;
            }
        }

        public Criteria andItemValueNotIn(List<String> values) {
            if (values.size() == 1) {
                return andItemValueNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysUserSettingDAO.ItemValue + " not in", values,
                    "itemValue");

                return this;
            }
        }

        public Criteria andItemValueIn(String[] values) {
            if (values.length == 1) {
                return andItemValueEqualTo(values[0]);
            } else {
                addCriterion(ISysUserSettingDAO.ItemValue + " in",
                    Arrays.asList(values), "itemValue");

                return this;
            }
        }

        public Criteria andItemValueNotIn(String[] values) {
            if (values.length == 1) {
                return andItemValueNotEqualTo(values[0]);
            } else {
                addCriterion(ISysUserSettingDAO.ItemValue + " not in",
                    Arrays.asList(values), "itemValue");

                return this;
            }
        }

        public Criteria andItemValueIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysUserSettingDAO.ItemValue + " in ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andItemValueNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysUserSettingDAO.ItemValue + " not in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andItemValueBetween(String value1, String value2) {
            addCriterion(ISysUserSettingDAO.ItemValue + " between", value1,
                value2, "itemValue");

            return this;
        }

        public Criteria andItemValueNotBetween(String value1, String value2) {
            addCriterion(ISysUserSettingDAO.ItemValue + " not between", value1,
                value2, "itemValue");

            return this;
        }
    }
}
